Creating a repository

The BlueCielo Meridian Explorer Database Wizard helps you to create and test a connection to a database server where you want to store the repository. You can use the BlueCielo Meridian Explorer Database Wizard to create connections to SQL Server or Oracle servers.

Before you begin

To use the BlueCielo Meridian Explorer Database Wizard wizard, you must know the name of either a Windows user account or a database account with permissions to access the database server and create database tables, indexes, and stored procedures. You also need to know the account password.

If you have sufficient privileges to create a new database on the database server, you can create the Meridian Explorer repository by performing the following task. If you have access to the database server with another account that does not have access from the Explorer server, see SQL Server database creation script or Oracle database creation script. If you do not have sufficient privileges, a database administrator will have to create the database for you.

To create a repository database on the database server:

1. Open BlueCielo Application Manager  from the Windows Start menu. The BlueCielo Application Manager console appears.
2. ExpandBlueCielo Meridian Explorer 2012 and select Repositories. The existing repository definitions appear in the right pane.
3. In the right pane, click the New Repository button . The New Repository dialog box appears.
4. Type a name for the repository in Name.
5. Select a database option for Provider.
6. Click Start the database wizard. The BlueCielo Meridian Explorer Database Wizard appears.
7. Read and confirm that you have met the database connection prerequisites.
8. Confirm that the database server meets the requirements for the FILESTREAM option or clear the option.

Note    This option requires that the Windows authentication option be used to access the database server in the following steps.

9. Click Next. The database connection options appear.
10. Click options or type values using the descriptions in the following table.

11. Click the Test connection button to test the current settings. The results will appear next to the button. If the test fails, correct the options that you selected in step 2 and retest.
12. When the test succeeds, click Next. The file path options appear.
13. Click options or type values using the descriptions in the following table.

Note    If you created the repository database manually, be sure to select the same paths that you specified.

14. Click Next. A summary of the current options appears.
15. Confirm the database creation settings are correct and click Finish. The status of the database creation process is displayed until it is finished.
16. Click Close. The resulting database provider and connection string appear in the corresponding options of the New Repository dialog.
17. Click OK. A new branch appears below Repositories with the name of the repository that you created.

After creating a repository and before vault synchronization with the repository can occur, at least one publishing job must be configured as described in  . Additional jobs for the same vault may be required to update the content index or to render thumbnail images.